	
/****** Object:  Stored Procedure CustomerProductsInsert    Script Date: Thursday, May 17, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spCustomerProductsInsert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spCustomerProductsInsert]
GO

	
	

/******************************************************************************
**		File: 
**		Name: spCustomerProductsInsert
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 5/17/2007 2:02:03 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE spCustomerProductsInsert
	@UserID int,
	@ProductCode varchar(10),
	@ReservedQty int,
	@ReservedDate datetime,
	@NumberOfDay int
AS

-- THIS STORED PROCEDURE NEEDS TO BE MANUALLY COMPLETED
-- MULITPLE PRIMARY KEY MEMBERS OR NON-GUID/INT PRIMARY KEY

INSERT INTO [CustomerProducts] (
	[UserID],
	[ProductCode],
	[ReservedQty],
	[ReservedDate],
	[NumberOfDay]
) VALUES (
	@UserID,
	@ProductCode,
	@ReservedQty,
	@ReservedDate,
	@NumberOfDay
)

GO
	
